Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 6081641 |
| Missing cells | 3655639 |
| Missing cells (%) | 4.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 696.0 MiB |
| Average record size in memory | 120.0 B |
Variable types
| Categorical | 9 |
|---|---|
| Numeric | 6 |
ride_id has a high cardinality: 6081641 distinct values | High cardinality |
started_at has a high cardinality: 5125092 distinct values | High cardinality |
ended_at has a high cardinality: 5138667 distinct values | High cardinality |
start_station_name has a high cardinality: 1702 distinct values | High cardinality |
start_station_id has a high cardinality: 1318 distinct values | High cardinality |
end_station_name has a high cardinality: 1725 distinct values | High cardinality |
end_station_id has a high cardinality: 1323 distinct values | High cardinality |
start_lat is highly correlated with start_lng and 1 other fields | High correlation |
start_lng is highly correlated with start_lat and 1 other fields | High correlation |
end_lat is highly correlated with start_lat and 1 other fields | High correlation |
end_lng is highly correlated with start_lng and 1 other fields | High correlation |
duration_in_mins is highly correlated with distance_km | High correlation |
distance_km is highly correlated with duration_in_mins | High correlation |
start_lat is highly correlated with start_lng and 1 other fields | High correlation |
start_lng is highly correlated with start_lat | High correlation |
end_lat is highly correlated with start_lat and 2 other fields | High correlation |
end_lng is highly correlated with end_lat and 1 other fields | High correlation |
distance_km is highly correlated with end_lat and 1 other fields | High correlation |
start_lat is highly correlated with end_lat | High correlation |
start_lng is highly correlated with end_lng | High correlation |
end_lat is highly correlated with start_lat | High correlation |
end_lng is highly correlated with start_lng | High correlation |
duration_in_mins is highly correlated with distance_km | High correlation |
distance_km is highly correlated with duration_in_mins | High correlation |
start_lat is highly correlated with start_lng | High correlation |
start_lng is highly correlated with start_lat | High correlation |
end_lat is highly correlated with end_lng and 1 other fields | High correlation |
end_lng is highly correlated with end_lat and 1 other fields | High correlation |
distance_km is highly correlated with end_lat and 1 other fields | High correlation |
start_station_name has 886328 (14.6%) missing values | Missing |
start_station_id has 886460 (14.6%) missing values | Missing |
end_station_name has 941355 (15.5%) missing values | Missing |
end_station_id has 941496 (15.5%) missing values | Missing |
end_lat is highly skewed (γ1 = -324.798497) | Skewed |
end_lng is highly skewed (γ1 = 771.2368006) | Skewed |
duration_in_mins is highly skewed (γ1 = 261.3644865) | Skewed |
distance_km is highly skewed (γ1 = 835.5510045) | Skewed |
ride_id is uniformly distributed | Uniform |
started_at is uniformly distributed | Uniform |
ended_at is uniformly distributed | Uniform |
ride_id has unique values | Unique |
duration_in_mins has 137843 (2.3%) zeros | Zeros |
distance_km has 328459 (5.4%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-30 04:45:39.104121 |
|---|---|
| Analysis finished | 2023-04-30 04:53:01.413675 |
| Duration | 7 minutes and 22.31 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 6081641 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.4 MiB |
| 550CF7EFEAE0C618 | 1 |
|---|---|
| D5D9F57D6DEE6573 | 1 |
| 8EA7198A672FD1BE | 1 |
| 69FB93A62F116E80 | 1 |
| 870F0ED4E79871E5 | 1 |
| Other values (6081636) |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 97306256 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 6081641 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 550CF7EFEAE0C618 |
|---|---|
| 2nd row | DAD198F405F9C5F5 |
| 3rd row | E6F2BC47B65CB7FD |
| 4th row | F597830181C2E13C |
| 5th row | 0CE689BB4E313E8D |
Common Values
| Value | Count | Frequency (%) |
| 550CF7EFEAE0C618 | 1 | < 0.1% |
| D5D9F57D6DEE6573 | 1 | < 0.1% |
| 8EA7198A672FD1BE | 1 | < 0.1% |
| 69FB93A62F116E80 | 1 | < 0.1% |
| 870F0ED4E79871E5 | 1 | < 0.1% |
| DA6B7A72B6FDF93F | 1 | < 0.1% |
| 3EF916074FFC3585 | 1 | < 0.1% |
| 7EA32BDFB6EEAC01 | 1 | < 0.1% |
| F4BFA36847700CDC | 1 | < 0.1% |
| EA716735F2E3DE70 | 1 | < 0.1% |
| Other values (6081631) | 6081631 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 550cf7efeae0c618 | 1 | < 0.1% |
| d2f6d8f3feed6874 | 1 | < 0.1% |
| 68c474a4e92f24b6 | 1 | < 0.1% |
| 14a985a3838aa8cc | 1 | < 0.1% |
| e724b94bce2e7e36 | 1 | < 0.1% |
| 1aa3756a6f8189db | 1 | < 0.1% |
| 1749361ac24efb77 | 1 | < 0.1% |
| cbc1e1c17b07a999 | 1 | < 0.1% |
| 3bbdd414f3f543ce | 1 | < 0.1% |
| 1edac7624ba69c98 | 1 | < 0.1% |
| Other values (6081631) | 6081631 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 6084749 | 6.3% |
| D | 6084627 | 6.3% |
| B | 6084436 | 6.3% |
| 9 | 6083751 | 6.3% |
| 3 | 6082816 | 6.3% |
| 2 | 6082576 | 6.3% |
| C | 6082564 | 6.3% |
| 6 | 6081493 | 6.2% |
| 5 | 6080971 | 6.2% |
| 0 | 6080899 | 6.2% |
| Other values (6) | 36477374 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 60809563 | |
| Uppercase Letter | 36496693 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 6083751 | |
| 3 | 6082816 | |
| 2 | 6082576 | |
| 6 | 6081493 | |
| 5 | 6080971 | |
| 0 | 6080899 | |
| 7 | 6080752 | |
| 8 | 6079863 | |
| 1 | 6079159 | |
| 4 | 6077283 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 6084749 | |
| D | 6084627 | |
| B | 6084436 | |
| C | 6082564 | |
| F | 6080899 | |
| E | 6079418 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 60809563 | |
| Latin | 36496693 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 9 | 6083751 | |
| 3 | 6082816 | |
| 2 | 6082576 | |
| 6 | 6081493 | |
| 5 | 6080971 | |
| 0 | 6080899 | |
| 7 | 6080752 | |
| 8 | 6079863 | |
| 1 | 6079159 | |
| 4 | 6077283 |
Latin
| Value | Count | Frequency (%) |
| A | 6084749 | |
| D | 6084627 | |
| B | 6084436 | |
| C | 6082564 | |
| F | 6080899 | |
| E | 6079418 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 97306256 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 6084749 | 6.3% |
| D | 6084627 | 6.3% |
| B | 6084436 | 6.3% |
| 9 | 6083751 | 6.3% |
| 3 | 6082816 | 6.3% |
| 2 | 6082576 | 6.3% |
| C | 6082564 | 6.3% |
| 6 | 6081493 | 6.2% |
| 5 | 6080971 | 6.2% |
| 0 | 6080899 | 6.2% |
| Other values (6) | 36477374 |
rideable_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.4 MiB |
| electric_bike | |
|---|---|
| classic_bike | |
| docked_bike | 179348 |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 12.48544644 |
| Min length | 11 |
Characters and Unicode
| Total characters | 75932003 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | electric_bike |
|---|---|
| 2nd row | electric_bike |
| 3rd row | electric_bike |
| 4th row | electric_bike |
| 5th row | electric_bike |
Common Values
| Value | Count | Frequency (%) |
| electric_bike | 3131659 | |
| classic_bike | 2770634 | |
| docked_bike | 179348 | 2.9% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| electric_bike | 3131659 | |
| classic_bike | 2770634 | |
| docked_bike | 179348 | 2.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 12524307 | |
| c | 11983934 | |
| i | 11983934 | |
| k | 6260989 | |
| _ | 6081641 | |
| b | 6081641 | |
| l | 5902293 | |
| s | 5541268 | |
| t | 3131659 | 4.1% |
| r | 3131659 | 4.1% |
| Other values (3) | 3308678 | 4.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 69850362 | |
| Connector Punctuation | 6081641 | 8.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 12524307 | |
| c | 11983934 | |
| i | 11983934 | |
| k | 6260989 | |
| b | 6081641 | |
| l | 5902293 | |
| s | 5541268 | |
| t | 3131659 | 4.5% |
| r | 3131659 | 4.5% |
| a | 2770634 | 4.0% |
| Other values (2) | 538044 | 0.8% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 6081641 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 69850362 | |
| Common | 6081641 | 8.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 12524307 | |
| c | 11983934 | |
| i | 11983934 | |
| k | 6260989 | |
| b | 6081641 | |
| l | 5902293 | |
| s | 5541268 | |
| t | 3131659 | 4.5% |
| r | 3131659 | 4.5% |
| a | 2770634 | 4.0% |
| Other values (2) | 538044 | 0.8% |
Common
| Value | Count | Frequency (%) |
| _ | 6081641 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75932003 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 12524307 | |
| c | 11983934 | |
| i | 11983934 | |
| k | 6260989 | |
| _ | 6081641 | |
| b | 6081641 | |
| l | 5902293 | |
| s | 5541268 | |
| t | 3131659 | 4.1% |
| r | 3131659 | 4.1% |
| Other values (3) | 3308678 | 4.4% |
| Distinct | 5125092 |
|---|---|
| Distinct (%) | 84.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.4 MiB |
| 2022-05-30 13:05:15 | 9 |
|---|---|
| 2022-07-09 17:23:31 | 8 |
| 2022-10-24 16:59:45 | 8 |
| 2022-10-03 17:22:27 | 8 |
| 2022-08-10 17:25:13 | 7 |
| Other values (5125087) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 115551179 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4310611 ? |
|---|---|
| Unique (%) | 70.9% |
Sample
| 1st row | 2022-08-07 21:34:15 |
|---|---|
| 2nd row | 2022-08-08 14:39:21 |
| 3rd row | 2022-08-08 15:29:50 |
| 4th row | 2022-08-08 02:43:50 |
| 5th row | 2022-08-07 20:24:06 |
Common Values
| Value | Count | Frequency (%) |
| 2022-05-30 13:05:15 | 9 | < 0.1% |
| 2022-07-09 17:23:31 | 8 | < 0.1% |
| 2022-10-24 16:59:45 | 8 | < 0.1% |
| 2022-10-03 17:22:27 | 8 | < 0.1% |
| 2022-08-10 17:25:13 | 7 | < 0.1% |
| 2022-07-27 17:05:02 | 7 | < 0.1% |
| 2022-05-29 12:56:58 | 7 | < 0.1% |
| 2022-06-02 18:25:07 | 7 | < 0.1% |
| 2022-09-03 11:43:56 | 7 | < 0.1% |
| 2022-07-14 17:49:58 | 7 | < 0.1% |
| Other values (5125082) | 6081566 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2022-07-09 | 36104 | 0.3% |
| 2022-04-23 | 34893 | 0.3% |
| 2022-06-18 | 34255 | 0.3% |
| 2022-05-29 | 33324 | 0.3% |
| 2022-07-30 | 33288 | 0.3% |
| 2022-06-26 | 32925 | 0.3% |
| 2022-07-16 | 32507 | 0.3% |
| 2022-06-11 | 32474 | 0.3% |
| 2022-08-27 | 32172 | 0.3% |
| 2022-05-28 | 31885 | 0.3% |
| Other values (86743) | 11829455 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 25163436 | |
| 0 | 19070578 | |
| 1 | 12275204 | |
| - | 12163282 | |
| : | 12163282 | |
| 6081641 | 5.3% | |
| 3 | 5871259 | 5.1% |
| 5 | 4894748 | 4.2% |
| 4 | 4614811 | 4.0% |
| 7 | 3465837 | 3.0% |
| Other values (3) | 9787101 | 8.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 85142974 | |
| Dash Punctuation | 12163282 | 10.5% |
| Other Punctuation | 12163282 | 10.5% |
| Space Separator | 6081641 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 25163436 | |
| 0 | 19070578 | |
| 1 | 12275204 | |
| 3 | 5871259 | 6.9% |
| 5 | 4894748 | 5.7% |
| 4 | 4614811 | 5.4% |
| 7 | 3465837 | 4.1% |
| 8 | 3388201 | 4.0% |
| 6 | 3234004 | 3.8% |
| 9 | 3164896 | 3.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12163282 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 12163282 |
Space Separator
| Value | Count | Frequency (%) |
| 6081641 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 115551179 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 25163436 | |
| 0 | 19070578 | |
| 1 | 12275204 | |
| - | 12163282 | |
| : | 12163282 | |
| 6081641 | 5.3% | |
| 3 | 5871259 | 5.1% |
| 5 | 4894748 | 4.2% |
| 4 | 4614811 | 4.0% |
| 7 | 3465837 | 3.0% |
| Other values (3) | 9787101 | 8.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 115551179 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 25163436 | |
| 0 | 19070578 | |
| 1 | 12275204 | |
| - | 12163282 | |
| : | 12163282 | |
| 6081641 | 5.3% | |
| 3 | 5871259 | 5.1% |
| 5 | 4894748 | 4.2% |
| 4 | 4614811 | 4.0% |
| 7 | 3465837 | 3.0% |
| Other values (3) | 9787101 | 8.5% |
| Distinct | 5138667 |
|---|---|
| Distinct (%) | 84.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.4 MiB |
| 2022-08-22 12:47:49 | 20 |
|---|---|
| 2022-06-22 08:01:59 | 14 |
| 2022-06-07 16:12:09 | 11 |
| 2023-03-22 17:30:49 | 11 |
| 2023-03-21 16:59:40 | 10 |
| Other values (5138662) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 115551179 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4331896 ? |
|---|---|
| Unique (%) | 71.2% |
Sample
| 1st row | 2022-08-07 21:41:46 |
|---|---|
| 2nd row | 2022-08-08 14:53:23 |
| 3rd row | 2022-08-08 15:40:34 |
| 4th row | 2022-08-08 02:58:53 |
| 5th row | 2022-08-07 20:29:58 |
Common Values
| Value | Count | Frequency (%) |
| 2022-08-22 12:47:49 | 20 | < 0.1% |
| 2022-06-22 08:01:59 | 14 | < 0.1% |
| 2022-06-07 16:12:09 | 11 | < 0.1% |
| 2023-03-22 17:30:49 | 11 | < 0.1% |
| 2023-03-21 16:59:40 | 10 | < 0.1% |
| 2022-08-19 15:02:42 | 9 | < 0.1% |
| 2022-08-22 12:47:50 | 9 | < 0.1% |
| 2022-09-06 17:51:39 | 8 | < 0.1% |
| 2022-06-03 17:34:16 | 8 | < 0.1% |
| 2022-08-19 16:21:17 | 8 | < 0.1% |
| Other values (5138657) | 6081533 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2022-07-09 | 36010 | 0.3% |
| 2022-04-23 | 34575 | 0.3% |
| 2022-06-18 | 34283 | 0.3% |
| 2022-05-29 | 33300 | 0.3% |
| 2022-07-30 | 33245 | 0.3% |
| 2022-06-26 | 33214 | 0.3% |
| 2022-06-11 | 32386 | 0.3% |
| 2022-07-16 | 32348 | 0.3% |
| 2022-08-27 | 32041 | 0.3% |
| 2022-09-10 | 31849 | 0.3% |
| Other values (86742) | 11830031 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 25238570 | |
| 0 | 19067520 | |
| 1 | 12207979 | |
| - | 12163282 | |
| : | 12163282 | |
| 6081641 | 5.3% | |
| 3 | 5872180 | 5.1% |
| 5 | 4919220 | 4.3% |
| 4 | 4586264 | 4.0% |
| 7 | 3442878 | 3.0% |
| Other values (3) | 9808363 | 8.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 85142974 | |
| Dash Punctuation | 12163282 | 10.5% |
| Other Punctuation | 12163282 | 10.5% |
| Space Separator | 6081641 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 25238570 | |
| 0 | 19067520 | |
| 1 | 12207979 | |
| 3 | 5872180 | 6.9% |
| 5 | 4919220 | 5.8% |
| 4 | 4586264 | 5.4% |
| 7 | 3442878 | 4.0% |
| 8 | 3416344 | 4.0% |
| 9 | 3198918 | 3.8% |
| 6 | 3193101 | 3.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12163282 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 12163282 |
Space Separator
| Value | Count | Frequency (%) |
| 6081641 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 115551179 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 25238570 | |
| 0 | 19067520 | |
| 1 | 12207979 | |
| - | 12163282 | |
| : | 12163282 | |
| 6081641 | 5.3% | |
| 3 | 5872180 | 5.1% |
| 5 | 4919220 | 4.3% |
| 4 | 4586264 | 4.0% |
| 7 | 3442878 | 3.0% |
| Other values (3) | 9808363 | 8.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 115551179 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 25238570 | |
| 0 | 19067520 | |
| 1 | 12207979 | |
| - | 12163282 | |
| : | 12163282 | |
| 6081641 | 5.3% | |
| 3 | 5872180 | 5.1% |
| 5 | 4919220 | 4.3% |
| 4 | 4586264 | 4.0% |
| 7 | 3442878 | 3.0% |
| Other values (3) | 9808363 | 8.5% |
| Distinct | 1702 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 886328 |
| Missing (%) | 14.6% |
| Memory size | 46.4 MiB |
| Streeter Dr & Grand Ave | 77051 |
|---|---|
| DuSable Lake Shore Dr & Monroe St | 42405 |
| Michigan Ave & Oak St | 40848 |
| DuSable Lake Shore Dr & North Blvd | 40810 |
| Wells St & Concord Ln | 39990 |
| Other values (1697) |
Length
| Max length | 64 |
|---|---|
| Median length | 50 |
| Mean length | 23.91537218 |
| Min length | 7 |
Characters and Unicode
| Total characters | 124247844 |
|---|---|
| Distinct characters | 72 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 111 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DuSable Museum |
|---|---|
| 2nd row | Robert Fulton Elementary School |
| 3rd row | California Ave & Milwaukee Ave |
| 4th row | Campbell Ave & Montrose Ave |
| 5th row | California Ave & Division St |
Common Values
| Value | Count | Frequency (%) |
| Streeter Dr & Grand Ave | 77051 | 1.3% |
| DuSable Lake Shore Dr & Monroe St | 42405 | 0.7% |
| Michigan Ave & Oak St | 40848 | 0.7% |
| DuSable Lake Shore Dr & North Blvd | 40810 | 0.7% |
| Wells St & Concord Ln | 39990 | 0.7% |
| Clark St & Elm St | 37805 | 0.6% |
| Kingsbury St & Kinzie St | 36412 | 0.6% |
| Millennium Park | 36298 | 0.6% |
| Wells St & Elm St | 33843 | 0.6% |
| Theater on the Lake | 33702 | 0.6% |
| Other values (1692) | 4776149 | |
| (Missing) | 886328 | 14.6% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 4936954 | ||
| st | 4552158 | |
| ave | 3673605 | 14.1% |
| dr | 379865 | 1.5% |
| clark | 378874 | 1.4% |
| lake | 334908 | 1.3% |
| blvd | 312073 | 1.2% |
| rd | 264340 | 1.0% |
| wells | 202036 | 0.8% |
| park | 192172 | 0.7% |
| Other values (775) | 10906111 |
Most occurring characters
| Value | Count | Frequency (%) |
| 20938019 | ||
| e | 10763904 | 8.7% |
| t | 8122379 | 6.5% |
| a | 6916077 | 5.6% |
| r | 5934353 | 4.8% |
| n | 5806928 | 4.7% |
| S | 5758029 | 4.6% |
| l | 5365248 | 4.3% |
| o | 5151405 | 4.1% |
| & | 4907807 | 4.0% |
| Other values (62) | 44583695 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 76211229 | |
| Space Separator | 20938019 | 16.9% |
| Uppercase Letter | 20905377 | 16.8% |
| Other Punctuation | 4983328 | 4.0% |
| Decimal Number | 994491 | 0.8% |
| Open Punctuation | 92983 | 0.1% |
| Close Punctuation | 92983 | 0.1% |
| Dash Punctuation | 29434 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 10763904 | |
| t | 8122379 | |
| a | 6916077 | |
| r | 5934353 | 7.8% |
| n | 5806928 | 7.6% |
| l | 5365248 | 7.0% |
| o | 5151405 | 6.8% |
| v | 4716835 | 6.2% |
| i | 4378690 | 5.7% |
| d | 2899451 | 3.8% |
| Other values (16) | 16155959 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 5758029 | |
| A | 4136147 | |
| C | 1429846 | 6.8% |
| W | 1277451 | 6.1% |
| D | 1119317 | 5.4% |
| L | 948692 | 4.5% |
| M | 887762 | 4.2% |
| B | 885771 | 4.2% |
| P | 791186 | 3.8% |
| R | 786337 | 3.8% |
| Other values (16) | 2884839 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 217034 | |
| 3 | 168381 | |
| 1 | 162035 | |
| 8 | 96490 | |
| 9 | 69314 | 7.0% |
| 6 | 65720 | 6.6% |
| 0 | 62352 | 6.3% |
| 7 | 55243 | 5.6% |
| 2 | 52809 | 5.3% |
| 4 | 45113 | 4.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 4907807 | |
| * | 43119 | 0.9% |
| . | 31592 | 0.6% |
| / | 801 | < 0.1% |
| " | 6 | < 0.1% |
| ; | 3 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 20938019 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 92983 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 92983 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 29434 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 97116606 | |
| Common | 27131238 | 21.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 10763904 | 11.1% |
| t | 8122379 | 8.4% |
| a | 6916077 | 7.1% |
| r | 5934353 | 6.1% |
| n | 5806928 | 6.0% |
| S | 5758029 | 5.9% |
| l | 5365248 | 5.5% |
| o | 5151405 | 5.3% |
| v | 4716835 | 4.9% |
| i | 4378690 | 4.5% |
| Other values (42) | 34202758 |
Common
| Value | Count | Frequency (%) |
| 20938019 | ||
| & | 4907807 | 18.1% |
| 5 | 217034 | 0.8% |
| 3 | 168381 | 0.6% |
| 1 | 162035 | 0.6% |
| 8 | 96490 | 0.4% |
| ( | 92983 | 0.3% |
| ) | 92983 | 0.3% |
| 9 | 69314 | 0.3% |
| 6 | 65720 | 0.2% |
| Other values (10) | 320472 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 124247844 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 20938019 | ||
| e | 10763904 | 8.7% |
| t | 8122379 | 6.5% |
| a | 6916077 | 5.6% |
| r | 5934353 | 4.8% |
| n | 5806928 | 4.7% |
| S | 5758029 | 4.6% |
| l | 5365248 | 4.3% |
| o | 5151405 | 4.1% |
| & | 4907807 | 4.0% |
| Other values (62) | 44583695 |
| Distinct | 1318 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 886460 |
| Missing (%) | 14.6% |
| Memory size | 46.4 MiB |
| 13022 | 77051 |
|---|---|
| 13300 | 42405 |
| 13042 | 40848 |
| LF-005 | 40810 |
| TA1308000050 | 39990 |
| Other values (1313) |
Length
| Max length | 37 |
|---|---|
| Median length | 36 |
| Mean length | 8.416704827 |
| Min length | 3 |
Characters and Unicode
| Total characters | 43726305 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 39 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | KA1503000075 |
|---|---|
| 2nd row | 819 |
| 3rd row | 13084 |
| 4th row | 15623 |
| 5th row | 13256 |
Common Values
| Value | Count | Frequency (%) |
| 13022 | 77051 | 1.3% |
| 13300 | 42405 | 0.7% |
| 13042 | 40848 | 0.7% |
| LF-005 | 40810 | 0.7% |
| TA1308000050 | 39990 | 0.7% |
| TA1307000039 | 37805 | 0.6% |
| KA1503000043 | 36412 | 0.6% |
| 13008 | 36298 | 0.6% |
| KA1504000135 | 33843 | 0.6% |
| TA1308000001 | 33702 | 0.6% |
| Other values (1308) | 4776017 | |
| (Missing) | 886460 | 14.6% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 13022 | 77051 | 1.5% |
| 13300 | 42405 | 0.8% |
| 13042 | 40848 | 0.8% |
| lf-005 | 40810 | 0.8% |
| ta1308000050 | 39990 | 0.8% |
| ta1307000039 | 37805 | 0.7% |
| ka1503000043 | 36412 | 0.7% |
| 13008 | 36298 | 0.7% |
| ka1504000135 | 33843 | 0.7% |
| ta1308000001 | 33702 | 0.6% |
| Other values (1325) | 4780531 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 14161433 | |
| 1 | 7005928 | |
| 3 | 5579234 | 12.8% |
| A | 2529047 | 5.8% |
| 5 | 2368241 | 5.4% |
| T | 2008835 | 4.6% |
| 2 | 1805677 | 4.1% |
| 4 | 1541706 | 3.5% |
| 6 | 1476587 | 3.4% |
| 7 | 1357654 | 3.1% |
| Other values (48) | 3891963 | 8.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 37352600 | |
| Uppercase Letter | 5583724 | 12.8% |
| Lowercase Letter | 510636 | 1.2% |
| Dash Punctuation | 236376 | 0.5% |
| Other Punctuation | 34587 | 0.1% |
| Space Separator | 4514 | < 0.1% |
| Close Punctuation | 1934 | < 0.1% |
| Open Punctuation | 1934 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2529047 | |
| T | 2008835 | |
| K | 537582 | 9.6% |
| L | 202339 | 3.6% |
| S | 102368 | 1.8% |
| W | 50115 | 0.9% |
| P | 41760 | 0.7% |
| F | 40810 | 0.7% |
| R | 30117 | 0.5% |
| N | 15103 | 0.3% |
| Other values (11) | 25648 | 0.5% |
Lowercase Letter
| Value | Count | Frequency (%) |
| g | 88369 | |
| i | 47327 | |
| c | 46999 | |
| a | 45478 | |
| n | 45326 | |
| r | 45239 | |
| h | 45215 | |
| t | 43540 | |
| s | 43520 | |
| x | 43119 | |
| Other values (11) | 16504 | 3.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 14161433 | |
| 1 | 7005928 | |
| 3 | 5579234 | 14.9% |
| 5 | 2368241 | 6.3% |
| 2 | 1805677 | 4.8% |
| 4 | 1541706 | 4.1% |
| 6 | 1476587 | 4.0% |
| 7 | 1357654 | 3.6% |
| 9 | 1235770 | 3.3% |
| 8 | 820370 | 2.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 34551 | |
| & | 36 | 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 236376 |
Space Separator
| Value | Count | Frequency (%) |
| 4514 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1934 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1934 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 37631945 | |
| Latin | 6094360 | 13.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 2529047 | |
| T | 2008835 | |
| K | 537582 | 8.8% |
| L | 202339 | 3.3% |
| S | 102368 | 1.7% |
| g | 88369 | 1.5% |
| W | 50115 | 0.8% |
| i | 47327 | 0.8% |
| c | 46999 | 0.8% |
| a | 45478 | 0.7% |
| Other values (32) | 435901 | 7.2% |
Common
| Value | Count | Frequency (%) |
| 0 | 14161433 | |
| 1 | 7005928 | |
| 3 | 5579234 | 14.8% |
| 5 | 2368241 | 6.3% |
| 2 | 1805677 | 4.8% |
| 4 | 1541706 | 4.1% |
| 6 | 1476587 | 3.9% |
| 7 | 1357654 | 3.6% |
| 9 | 1235770 | 3.3% |
| 8 | 820370 | 2.2% |
| Other values (6) | 279345 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43726305 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 14161433 | |
| 1 | 7005928 | |
| 3 | 5579234 | 12.8% |
| A | 2529047 | 5.8% |
| 5 | 2368241 | 5.4% |
| T | 2008835 | 4.6% |
| 2 | 1805677 | 4.1% |
| 4 | 1541706 | 3.5% |
| 6 | 1476587 | 3.4% |
| 7 | 1357654 | 3.1% |
| Other values (48) | 3891963 | 8.9% |
| Distinct | 1725 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 941355 |
| Missing (%) | 15.5% |
| Memory size | 46.4 MiB |
| Streeter Dr & Grand Ave | 77569 |
|---|---|
| DuSable Lake Shore Dr & North Blvd | 42978 |
| Michigan Ave & Oak St | 41397 |
| DuSable Lake Shore Dr & Monroe St | 41168 |
| Wells St & Concord Ln | 40053 |
| Other values (1720) |
Length
| Max length | 64 |
|---|---|
| Median length | 50 |
| Mean length | 23.92562301 |
| Min length | 9 |
Characters and Unicode
| Total characters | 122984545 |
|---|---|
| Distinct characters | 71 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 129 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Western Ave & Roscoe St |
|---|---|
| 2nd row | Western Ave & 105th St |
| 3rd row | Cottage Grove Ave & 51st St |
| 4th row | Campbell Ave & Montrose Ave |
| 5th row | California Ave & Milwaukee Ave |
Common Values
| Value | Count | Frequency (%) |
| Streeter Dr & Grand Ave | 77569 | 1.3% |
| DuSable Lake Shore Dr & North Blvd | 42978 | 0.7% |
| Michigan Ave & Oak St | 41397 | 0.7% |
| DuSable Lake Shore Dr & Monroe St | 41168 | 0.7% |
| Wells St & Concord Ln | 40053 | 0.7% |
| Clark St & Elm St | 37216 | 0.6% |
| Millennium Park | 36787 | 0.6% |
| Kingsbury St & Kinzie St | 35217 | 0.6% |
| Theater on the Lake | 33844 | 0.6% |
| Wells St & Elm St | 32767 | 0.5% |
| Other values (1715) | 4721290 | |
| (Missing) | 941355 | 15.5% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 4889402 | ||
| st | 4491116 | |
| ave | 3667362 | 14.2% |
| clark | 374302 | 1.4% |
| dr | 373823 | 1.4% |
| lake | 335533 | 1.3% |
| blvd | 307603 | 1.2% |
| rd | 261072 | 1.0% |
| wells | 193303 | 0.7% |
| park | 189759 | 0.7% |
| Other values (777) | 10773964 |
Most occurring characters
| Value | Count | Frequency (%) |
| 20717213 | ||
| e | 10701986 | 8.7% |
| t | 8029001 | 6.5% |
| a | 6832163 | 5.6% |
| r | 5871803 | 4.8% |
| n | 5746719 | 4.7% |
| S | 5691320 | 4.6% |
| l | 5309195 | 4.3% |
| o | 5113172 | 4.2% |
| & | 4861467 | 4.0% |
| Other values (61) | 44110506 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 75461147 | |
| Space Separator | 20717213 | 16.8% |
| Uppercase Letter | 20680332 | 16.8% |
| Other Punctuation | 4940441 | 4.0% |
| Decimal Number | 974994 | 0.8% |
| Close Punctuation | 91141 | 0.1% |
| Open Punctuation | 91141 | 0.1% |
| Dash Punctuation | 28136 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 10701986 | |
| t | 8029001 | |
| a | 6832163 | |
| r | 5871803 | 7.8% |
| n | 5746719 | 7.6% |
| l | 5309195 | 7.0% |
| o | 5113172 | 6.8% |
| v | 4701198 | 6.2% |
| i | 4330332 | 5.7% |
| d | 2867629 | 3.8% |
| Other values (16) | 15957949 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 5691320 | |
| A | 4122411 | |
| C | 1413570 | 6.8% |
| W | 1255349 | 6.1% |
| D | 1109389 | 5.4% |
| L | 945821 | 4.6% |
| M | 878274 | 4.2% |
| B | 876836 | 4.2% |
| R | 780881 | 3.8% |
| P | 773865 | 3.7% |
| Other values (16) | 2832616 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 214224 | |
| 3 | 166676 | |
| 1 | 159632 | |
| 8 | 94672 | |
| 9 | 66882 | 6.9% |
| 6 | 64091 | 6.6% |
| 0 | 60322 | 6.2% |
| 7 | 54873 | 5.6% |
| 2 | 49302 | 5.1% |
| 4 | 44320 | 4.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 4861467 | |
| * | 45957 | 0.9% |
| . | 32295 | 0.7% |
| / | 712 | < 0.1% |
| " | 10 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 20717213 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 91141 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 91141 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 28136 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 96141479 | |
| Common | 26843066 | 21.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 10701986 | 11.1% |
| t | 8029001 | 8.4% |
| a | 6832163 | 7.1% |
| r | 5871803 | 6.1% |
| n | 5746719 | 6.0% |
| S | 5691320 | 5.9% |
| l | 5309195 | 5.5% |
| o | 5113172 | 5.3% |
| v | 4701198 | 4.9% |
| i | 4330332 | 4.5% |
| Other values (42) | 33814590 |
Common
| Value | Count | Frequency (%) |
| 20717213 | ||
| & | 4861467 | 18.1% |
| 5 | 214224 | 0.8% |
| 3 | 166676 | 0.6% |
| 1 | 159632 | 0.6% |
| 8 | 94672 | 0.4% |
| ) | 91141 | 0.3% |
| ( | 91141 | 0.3% |
| 9 | 66882 | 0.2% |
| 6 | 64091 | 0.2% |
| Other values (9) | 315927 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 122984545 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 20717213 | ||
| e | 10701986 | 8.7% |
| t | 8029001 | 6.5% |
| a | 6832163 | 5.6% |
| r | 5871803 | 4.8% |
| n | 5746719 | 4.7% |
| S | 5691320 | 4.6% |
| l | 5309195 | 4.3% |
| o | 5113172 | 4.2% |
| & | 4861467 | 4.0% |
| Other values (61) | 44110506 |
| Distinct | 1323 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 941496 |
| Missing (%) | 15.5% |
| Memory size | 46.4 MiB |
| 13022 | 77569 |
|---|---|
| LF-005 | 42978 |
| 13042 | 41397 |
| 13300 | 41168 |
| TA1308000050 | 40053 |
| Other values (1318) |
Length
| Max length | 37 |
|---|---|
| Median length | 36 |
| Mean length | 8.422088482 |
| Min length | 3 |
Characters and Unicode
| Total characters | 43290756 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 36 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 15634 |
|---|---|
| 2nd row | 691 |
| 3rd row | TA1309000067 |
| 4th row | 15623 |
| 5th row | 13084 |
Common Values
| Value | Count | Frequency (%) |
| 13022 | 77569 | 1.3% |
| LF-005 | 42978 | 0.7% |
| 13042 | 41397 | 0.7% |
| 13300 | 41168 | 0.7% |
| TA1308000050 | 40053 | 0.7% |
| TA1307000039 | 37216 | 0.6% |
| 13008 | 36787 | 0.6% |
| KA1503000043 | 35217 | 0.6% |
| TA1308000001 | 33844 | 0.6% |
| KA1504000135 | 32767 | 0.5% |
| Other values (1313) | 4721149 | |
| (Missing) | 941496 | 15.5% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 13022 | 77569 | 1.5% |
| lf-005 | 42978 | 0.8% |
| 13042 | 41397 | 0.8% |
| 13300 | 41168 | 0.8% |
| ta1308000050 | 40053 | 0.8% |
| ta1307000039 | 37216 | 0.7% |
| 13008 | 36787 | 0.7% |
| ka1503000043 | 35217 | 0.7% |
| ta1308000001 | 33844 | 0.7% |
| ka1504000135 | 32767 | 0.6% |
| Other values (1330) | 4721953 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 14029638 | |
| 1 | 6956014 | |
| 3 | 5524161 | 12.8% |
| A | 2509406 | 5.8% |
| 5 | 2352498 | 5.4% |
| T | 1989789 | 4.6% |
| 2 | 1773498 | 4.1% |
| 4 | 1528660 | 3.5% |
| 6 | 1454611 | 3.4% |
| 7 | 1344389 | 3.1% |
| Other values (48) | 3828092 | 8.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 37004902 | |
| Uppercase Letter | 5516043 | 12.7% |
| Lowercase Letter | 510766 | 1.2% |
| Dash Punctuation | 227455 | 0.5% |
| Other Punctuation | 30336 | 0.1% |
| Space Separator | 804 | < 0.1% |
| Close Punctuation | 225 | < 0.1% |
| Open Punctuation | 225 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2509406 | |
| T | 1989789 | |
| K | 532678 | 9.7% |
| L | 196907 | 3.6% |
| S | 93108 | 1.7% |
| W | 48502 | 0.9% |
| F | 42978 | 0.8% |
| P | 40699 | 0.7% |
| R | 30063 | 0.5% |
| N | 14882 | 0.3% |
| Other values (11) | 17031 | 0.3% |
Lowercase Letter
| Value | Count | Frequency (%) |
| g | 92247 | |
| i | 46558 | |
| c | 46427 | |
| a | 46320 | |
| r | 46268 | |
| n | 46258 | |
| h | 46248 | |
| t | 46059 | |
| s | 46042 | |
| x | 45959 | |
| Other values (11) | 2380 | 0.5% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 14029638 | |
| 1 | 6956014 | |
| 3 | 5524161 | 14.9% |
| 5 | 2352498 | 6.4% |
| 2 | 1773498 | 4.8% |
| 4 | 1528660 | 4.1% |
| 6 | 1454611 | 3.9% |
| 7 | 1344389 | 3.6% |
| 9 | 1224906 | 3.3% |
| 8 | 816527 | 2.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 30298 | |
| & | 38 | 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 227455 |
Space Separator
| Value | Count | Frequency (%) |
| 804 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 225 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 225 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 37263947 | |
| Latin | 6026809 | 13.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 2509406 | |
| T | 1989789 | |
| K | 532678 | 8.8% |
| L | 196907 | 3.3% |
| S | 93108 | 1.5% |
| g | 92247 | 1.5% |
| W | 48502 | 0.8% |
| i | 46558 | 0.8% |
| c | 46427 | 0.8% |
| a | 46320 | 0.8% |
| Other values (32) | 424867 | 7.0% |
Common
| Value | Count | Frequency (%) |
| 0 | 14029638 | |
| 1 | 6956014 | |
| 3 | 5524161 | 14.8% |
| 5 | 2352498 | 6.3% |
| 2 | 1773498 | 4.8% |
| 4 | 1528660 | 4.1% |
| 6 | 1454611 | 3.9% |
| 7 | 1344389 | 3.6% |
| 9 | 1224906 | 3.3% |
| 8 | 816527 | 2.2% |
| Other values (6) | 259045 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43290756 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 14029638 | |
| 1 | 6956014 | |
| 3 | 5524161 | 12.8% |
| A | 2509406 | 5.8% |
| 5 | 2352498 | 5.4% |
| T | 1989789 | 4.6% |
| 2 | 1773498 | 4.1% |
| 4 | 1528660 | 3.5% |
| 6 | 1454611 | 3.4% |
| 7 | 1344389 | 3.1% |
| Other values (48) | 3828092 | 8.8% |
| Distinct | 722564 |
|---|---|
| Distinct (%) | 11.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.90206158 |
| Minimum | 41.64 |
|---|---|
| Maximum | 42.07 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.4 MiB |
Quantile statistics
| Minimum | 41.64 |
|---|---|
| 5-th percentile | 41.8 |
| Q1 | 41.88096617 |
| median | 41.89993001 |
| Q3 | 41.93 |
| 95-th percentile | 41.97 |
| Maximum | 42.07 |
| Range | 0.43 |
| Interquartile range (IQR) | 0.04903383333 |
Descriptive statistics
| Standard deviation | 0.0462265043 |
|---|---|
| Coefficient of variation (CV) | 0.001103203579 |
| Kurtosis | 2.14375908 |
| Mean | 41.90206158 |
| Median Absolute Deviation (MAD) | 0.02274901 |
| Skewness | -0.4768937608 |
| Sum | 254833295.7 |
| Variance | 0.0021368897 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 41.93 | 99695 | 1.6% |
| 41.89 | 95050 | 1.6% |
| 41.92 | 92209 | 1.5% |
| 41.94 | 83274 | 1.4% |
| 41.91 | 81587 | 1.3% |
| 41.9 | 73058 | 1.2% |
| 41.88 | 64844 | 1.1% |
| 41.95 | 63830 | 1.0% |
| 41.892278 | 53873 | 0.9% |
| 41.79 | 47505 | 0.8% |
| Other values (722554) | 5326716 |
| Value | Count | Frequency (%) |
| 41.64 | 3 | < 0.1% |
| 41.64850076 | 85 | |
| 41.648501 | 8 | < 0.1% |
| 41.64853067 | 1 | < 0.1% |
| 41.64854717 | 1 | < 0.1% |
| 41.648552 | 1 | < 0.1% |
| 41.64855417 | 1 | < 0.1% |
| 41.64855483 | 1 | < 0.1% |
| 41.64855783 | 1 | < 0.1% |
| 41.64855945 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 42.07 | 305 | |
| 42.06486917 | 1 | < 0.1% |
| 42.06485633 | 1 | < 0.1% |
| 42.064854 | 350 | |
| 42.06485033 | 1 | < 0.1% |
| 42.0648435 | 1 | < 0.1% |
| 42.0648425 | 1 | < 0.1% |
| 42.06483996 | 1 | < 0.1% |
| 42.06483767 | 1 | < 0.1% |
| 42.06482833 | 1 | < 0.1% |
| Distinct | 682475 |
|---|---|
| Distinct (%) | 11.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -87.64779682 |
| Minimum | -87.84 |
|---|---|
| Maximum | -87.52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 6081641 |
| Negative (%) | 100.0% |
| Memory size | 46.4 MiB |
Quantile statistics
| Minimum | -87.84 |
|---|---|
| 5-th percentile | -87.7 |
| Q1 | -87.661501 |
| median | -87.64410555 |
| Q3 | -87.629634 |
| 95-th percentile | -87.607267 |
| Maximum | -87.52 |
| Range | 0.32 |
| Interquartile range (IQR) | 0.031867 |
Descriptive statistics
| Standard deviation | 0.02920161611 |
|---|---|
| Coefficient of variation (CV) | -0.0003331699959 |
| Kurtosis | 2.910488901 |
| Mean | -87.64779682 |
| Median Absolute Deviation (MAD) | 0.015894446 |
| Skewness | -0.9905368322 |
| Sum | -533042434.7 |
| Variance | 0.0008527343832 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -87.65 | 138302 | 2.3% |
| -87.63 | 103546 | 1.7% |
| -87.64 | 91466 | 1.5% |
| -87.66 | 84833 | 1.4% |
| -87.67 | 73781 | 1.2% |
| -87.69 | 68184 | 1.1% |
| -87.68 | 63469 | 1.0% |
| -87.7 | 59692 | 1.0% |
| -87.612043 | 53859 | 0.9% |
| -87.62 | 51929 | 0.9% |
| Other values (682465) | 5292580 |
| Value | Count | Frequency (%) |
| -87.84 | 22 | < 0.1% |
| -87.8333205 | 1 | < 0.1% |
| -87.8333085 | 1 | < 0.1% |
| -87.8332685 | 1 | < 0.1% |
| -87.83325417 | 1 | < 0.1% |
| -87.83324883 | 1 | < 0.1% |
| -87.83323517 | 1 | < 0.1% |
| -87.83322867 | 1 | < 0.1% |
| -87.83 | 675 | |
| -87.8293115 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -87.52 | 30 | < 0.1% |
| -87.525314 | 1 | < 0.1% |
| -87.52823174 | 142 | |
| -87.528232 | 28 | < 0.1% |
| -87.52833083 | 1 | < 0.1% |
| -87.528355 | 1 | < 0.1% |
| -87.52836583 | 1 | < 0.1% |
| -87.52837 | 1 | < 0.1% |
| -87.52837083 | 1 | < 0.1% |
| -87.52838033 | 1 | < 0.1% |
| Distinct | 1634 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.9022444 |
| Minimum | 0 |
|---|---|
| Maximum | 42.37 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 41.8 |
| Q1 | 41.8810317 |
| median | 41.9 |
| Q3 | 41.93 |
| 95-th percentile | 41.97 |
| Maximum | 42.37 |
| Range | 42.37 |
| Interquartile range (IQR) | 0.0489683 |
Descriptive statistics
| Standard deviation | 0.06680262885 |
|---|---|
| Coefficient of variation (CV) | 0.001594249421 |
| Kurtosis | 203629.5423 |
| Mean | 41.9022444 |
| Median Absolute Deviation (MAD) | 0.022819 |
| Skewness | -324.798497 |
| Sum | 254834407.5 |
| Variance | 0.004462591221 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 41.93 | 101809 | 1.7% |
| 41.89 | 101481 | 1.7% |
| 41.92 | 94602 | 1.6% |
| 41.91 | 85113 | 1.4% |
| 41.94 | 84475 | 1.4% |
| 41.892278 | 77550 | 1.3% |
| 41.9 | 76158 | 1.3% |
| 41.88 | 70296 | 1.2% |
| 41.95 | 65069 | 1.1% |
| 41.79 | 48395 | 0.8% |
| Other values (1624) | 5276693 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 41.55 | 4 | < 0.1% |
| 41.59 | 1 | < 0.1% |
| 41.6 | 2 | < 0.1% |
| 41.61 | 1 | < 0.1% |
| 41.62 | 3 | < 0.1% |
| 41.63 | 5 | < 0.1% |
| 41.64 | 11 | < 0.1% |
| 41.64850076 | 89 | |
| 41.648501 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 42.37 | 1 | < 0.1% |
| 42.19 | 2 | < 0.1% |
| 42.15 | 1 | < 0.1% |
| 42.13 | 2 | < 0.1% |
| 42.12 | 2 | < 0.1% |
| 42.11 | 5 | < 0.1% |
| 42.1 | 2 | < 0.1% |
| 42.09 | 3 | < 0.1% |
| 42.08 | 41 | < 0.1% |
| 42.07 | 385 |
| Distinct | 1619 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -87.64786739 |
| Minimum | -88.14 |
|---|---|
| Maximum | 0 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 6081633 |
| Negative (%) | > 99.9% |
| Memory size | 46.4 MiB |
Quantile statistics
| Minimum | -88.14 |
|---|---|
| 5-th percentile | -87.7 |
| Q1 | -87.662007 |
| median | -87.64414 |
| Q3 | -87.62974631 |
| 95-th percentile | -87.607267 |
| Maximum | 0 |
| Range | 88.14 |
| Interquartile range (IQR) | 0.0322606948 |
Descriptive statistics
| Standard deviation | 0.1047203596 |
|---|---|
| Coefficient of variation (CV) | -0.001194785027 |
| Kurtosis | 645518.4026 |
| Mean | -87.64786739 |
| Median Absolute Deviation (MAD) | 0.01586 |
| Skewness | 771.2368006 |
| Sum | -533042863.9 |
| Variance | 0.01096635371 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -87.65 | 143424 | 2.4% |
| -87.63 | 111969 | 1.8% |
| -87.64 | 96507 | 1.6% |
| -87.66 | 88477 | 1.5% |
| -87.612043 | 77550 | 1.3% |
| -87.67 | 77432 | 1.3% |
| -87.69 | 68840 | 1.1% |
| -87.68 | 65148 | 1.1% |
| -87.7 | 59483 | 1.0% |
| -87.62 | 57626 | 0.9% |
| Other values (1609) | 5235185 |
| Value | Count | Frequency (%) |
| -88.14 | 1 | < 0.1% |
| -88.05 | 1 | < 0.1% |
| -87.93 | 1 | < 0.1% |
| -87.92 | 4 | |
| -87.9 | 1 | < 0.1% |
| -87.89 | 3 | < 0.1% |
| -87.88 | 4 | |
| -87.87 | 3 | < 0.1% |
| -87.86 | 8 | |
| -87.85 | 7 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| -87.3 | 4 | < 0.1% |
| -87.5 | 1 | < 0.1% |
| -87.51 | 6 | < 0.1% |
| -87.52 | 52 | < 0.1% |
| -87.52823174 | 223 | |
| -87.528232 | 30 | < 0.1% |
| -87.52845117 | 1 | < 0.1% |
| -87.53 | 332 | |
| -87.530431 | 90 | < 0.1% |
member_casual
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.4 MiB |
| member | |
|---|---|
| casual |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 36489846 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | casual |
|---|---|
| 2nd row | casual |
| 3rd row | casual |
| 4th row | casual |
| 5th row | casual |
Common Values
| Value | Count | Frequency (%) |
| member | 3659726 | |
| casual | 2421915 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| member | 3659726 | |
| casual | 2421915 |
Most occurring characters
| Value | Count | Frequency (%) |
| m | 7319452 | |
| e | 7319452 | |
| a | 4843830 | |
| b | 3659726 | |
| r | 3659726 | |
| c | 2421915 | 6.6% |
| s | 2421915 | 6.6% |
| u | 2421915 | 6.6% |
| l | 2421915 | 6.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 36489846 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| m | 7319452 | |
| e | 7319452 | |
| a | 4843830 | |
| b | 3659726 | |
| r | 3659726 | |
| c | 2421915 | 6.6% |
| s | 2421915 | 6.6% |
| u | 2421915 | 6.6% |
| l | 2421915 | 6.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 36489846 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| m | 7319452 | |
| e | 7319452 | |
| a | 4843830 | |
| b | 3659726 | |
| r | 3659726 | |
| c | 2421915 | 6.6% |
| s | 2421915 | 6.6% |
| u | 2421915 | 6.6% |
| l | 2421915 | 6.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 36489846 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| m | 7319452 | |
| e | 7319452 | |
| a | 4843830 | |
| b | 3659726 | |
| r | 3659726 | |
| c | 2421915 | 6.6% |
| s | 2421915 | 6.6% |
| u | 2421915 | 6.6% |
| l | 2421915 | 6.6% |
| Distinct | 1495 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.41898691 |
| Minimum | -10354 |
|---|---|
| Maximum | 34354 |
| Zeros | 137843 |
| Zeros (%) | 2.3% |
| Negative | 101 |
| Negative (%) | < 0.1% |
| Memory size | 46.4 MiB |
Quantile statistics
| Minimum | -10354 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 10 |
| Q3 | 17 |
| 95-th percentile | 43 |
| Maximum | 34354 |
| Range | 44708 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 37.75881048 |
|---|---|
| Coefficient of variation (CV) | 2.448851581 |
| Kurtosis | 207129.8497 |
| Mean | 15.41898691 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 261.3644865 |
| Sum | 93772743 |
| Variance | 1425.727769 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5 | 404947 | 6.7% |
| 4 | 402503 | 6.6% |
| 6 | 387523 | 6.4% |
| 7 | 361315 | 5.9% |
| 3 | 354935 | 5.8% |
| 8 | 331728 | 5.5% |
| 9 | 302725 | 5.0% |
| 10 | 273087 | 4.5% |
| 11 | 242918 | 4.0% |
| 2 | 241929 | 4.0% |
| Other values (1485) | 2778031 |
| Value | Count | Frequency (%) |
| -10354 | 1 | |
| -169 | 1 | |
| -138 | 1 | |
| -131 | 1 | |
| -130 | 1 | |
| -128 | 1 | |
| -127 | 1 | |
| -126 | 1 | |
| -118 | 1 | |
| -102 | 1 |
| Value | Count | Frequency (%) |
| 34354 | 1 | |
| 32035 | 1 | |
| 13928 | 1 | |
| 10807 | 1 | |
| 10722 | 1 | |
| 10126 | 1 | |
| 9962 | 1 | |
| 8755 | 1 | |
| 8243 | 1 | |
| 7545 | 1 |
distance_km
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 114173 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.11474072 |
| Minimum | 0 |
|---|---|
| Maximum | 9814.083 |
| Zeros | 328459 |
| Zeros (%) | 5.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.865 |
| median | 1.552 |
| Q3 | 2.7543 |
| 95-th percentile | 5.8655 |
| Maximum | 9814.083 |
| Range | 9814.083 |
| Interquartile range (IQR) | 1.8893 |
Descriptive statistics
| Standard deviation | 11.41293769 |
|---|---|
| Coefficient of variation (CV) | 5.396849638 |
| Kurtosis | 718233.5981 |
| Mean | 2.11474072 |
| Median Absolute Deviation (MAD) | 0.8269 |
| Skewness | 835.5510045 |
| Sum | 12861093.87 |
| Variance | 130.2551467 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 328459 | 5.4% |
| 1.112 | 60088 | 1.0% |
| 2.2239 | 16388 | 0.3% |
| 0.7166 | 13431 | 0.2% |
| 1.0239 | 12274 | 0.2% |
| 1.386 | 12191 | 0.2% |
| 1.387 | 11299 | 0.2% |
| 0.8272 | 7393 | 0.1% |
| 1.3175 | 7237 | 0.1% |
| 0.8291 | 6832 | 0.1% |
| Other values (114163) | 5606049 |
| Value | Count | Frequency (%) |
| 0 | 328459 | |
| 0.0001 | 28 | < 0.1% |
| 0.0002 | 48 | < 0.1% |
| 0.0003 | 78 | < 0.1% |
| 0.0004 | 124 | < 0.1% |
| 0.0005 | 112 | < 0.1% |
| 0.0006 | 159 | < 0.1% |
| 0.0007 | 182 | < 0.1% |
| 0.0008 | 193 | < 0.1% |
| 0.0009 | 227 | < 0.1% |
| Value | Count | Frequency (%) |
| 9814.083 | 1 | |
| 9813.3911 | 1 | |
| 9813.0858 | 1 | |
| 9812.9313 | 1 | |
| 9812.9299 | 1 | |
| 9812.1879 | 1 | |
| 9811.8243 | 1 | |
| 9811.5246 | 1 | |
| 42.2722 | 1 | |
| 37.6787 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.
First rows
| ride_id | rideable_type | started_at | ended_at | start_station_name | start_station_id | end_station_name | end_station_id | start_lat | start_lng | end_lat | end_lng | member_casual | duration_in_mins | distance_km | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 550CF7EFEAE0C618 | electric_bike | 2022-08-07 21:34:15 | 2022-08-07 21:41:46 | NaN | NaN | NaN | NaN | 41.93 | -87.69 | 41.94 | -87.72 | casual | 7.0 | 2.7193 |
| 1 | DAD198F405F9C5F5 | electric_bike | 2022-08-08 14:39:21 | 2022-08-08 14:53:23 | NaN | NaN | NaN | NaN | 41.89 | -87.64 | 41.92 | -87.64 | casual | 14.0 | 3.3359 |
| 2 | E6F2BC47B65CB7FD | electric_bike | 2022-08-08 15:29:50 | 2022-08-08 15:40:34 | NaN | NaN | NaN | NaN | 41.97 | -87.69 | 41.97 | -87.66 | casual | 10.0 | 2.4802 |
| 3 | F597830181C2E13C | electric_bike | 2022-08-08 02:43:50 | 2022-08-08 02:58:53 | NaN | NaN | NaN | NaN | 41.94 | -87.65 | 41.97 | -87.69 | casual | 15.0 | 4.6977 |
| 4 | 0CE689BB4E313E8D | electric_bike | 2022-08-07 20:24:06 | 2022-08-07 20:29:58 | NaN | NaN | NaN | NaN | 41.85 | -87.65 | 41.84 | -87.66 | casual | 5.0 | 1.3866 |
| 5 | BFA7E7CC69860C20 | electric_bike | 2022-08-08 13:06:08 | 2022-08-08 13:19:09 | NaN | NaN | NaN | NaN | 41.79 | -87.72 | 41.82 | -87.69 | casual | 13.0 | 4.1607 |
| 6 | 68C474A4E92F24B6 | electric_bike | 2022-08-08 14:02:40 | 2022-08-08 14:11:36 | NaN | NaN | NaN | NaN | 41.89 | -87.63 | 41.89 | -87.61 | casual | 8.0 | 1.6555 |
| 7 | 14A985A3838AA8CC | electric_bike | 2022-08-07 20:56:17 | 2022-08-07 21:14:14 | NaN | NaN | NaN | NaN | 41.96 | -87.68 | 41.92 | -87.68 | casual | 17.0 | 4.4478 |
| 8 | E724B94BCE2E7E36 | electric_bike | 2022-08-07 21:30:05 | 2022-08-07 21:41:28 | NaN | NaN | NaN | NaN | 41.92 | -87.68 | 41.93 | -87.72 | casual | 11.0 | 3.4911 |
| 9 | 1AA3756A6F8189DB | electric_bike | 2022-08-07 23:53:05 | 2022-08-08 00:04:14 | NaN | NaN | NaN | NaN | 41.93 | -87.72 | 41.92 | -87.68 | casual | 11.0 | 3.4911 |
Last rows
| ride_id | rideable_type | started_at | ended_at | start_station_name | start_station_id | end_station_name | end_station_id | start_lat | start_lng | end_lat | end_lng | member_casual | duration_in_mins | distance_km | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6081631 | 6DEFEFE78E1277D1 | classic_bike | 2023-01-09 12:31:57 | 2023-01-09 12:44:30 | Clark St & Elm St | TA1307000039 | Southport Ave & Clybourn Ave | TA1309000030 | 41.902973 | -87.631280 | 41.920771 | -87.663712 | casual | 12.0 | 3.3345 |
| 6081632 | 0CB0D8048D672CE7 | electric_bike | 2023-01-04 17:30:21 | 2023-01-04 17:42:12 | Clark St & Elm St | TA1307000039 | Southport Ave & Clybourn Ave | TA1309000030 | 41.902875 | -87.631781 | 41.920771 | -87.663712 | casual | 11.0 | 3.3078 |
| 6081633 | 8D7369B7FE52D037 | electric_bike | 2023-01-20 18:21:26 | 2023-01-20 18:55:42 | Ogden Ave & Congress Pkwy | 13081 | Clarendon Ave & Gordon Ter | 13379 | 41.874960 | -87.673230 | 41.957867 | -87.649505 | member | 34.0 | 9.4254 |
| 6081634 | 920FD3D051E63678 | electric_bike | 2023-01-17 18:39:41 | 2023-01-17 19:00:33 | Clark St & Elm St | TA1307000039 | Southport Ave & Clybourn Ave | TA1309000030 | 41.902781 | -87.631663 | 41.920771 | -87.663712 | casual | 20.0 | 3.3218 |
| 6081635 | A3DC3E8358DB1FAA | electric_bike | 2023-01-17 18:36:00 | 2023-01-17 19:00:26 | Clark St & Elm St | TA1307000039 | Southport Ave & Clybourn Ave | TA1309000030 | 41.902760 | -87.631491 | 41.920771 | -87.663712 | casual | 24.0 | 3.3347 |
| 6081636 | A303816F2E8A35A8 | electric_bike | 2023-01-11 17:46:23 | 2023-01-11 17:57:31 | Clark St & Elm St | TA1307000039 | Southport Ave & Clybourn Ave | TA1309000030 | 41.902634 | -87.631591 | 41.920771 | -87.663712 | casual | 11.0 | 3.3365 |
| 6081637 | BCDBB142CC610382 | classic_bike | 2023-01-30 15:08:10 | 2023-01-30 15:33:26 | Western Ave & Leland Ave | TA1307000140 | Clarendon Ave & Gordon Ter | 13379 | 41.966400 | -87.688704 | 41.957867 | -87.649505 | member | 25.0 | 3.3771 |
| 6081638 | 7D1C7CA80517183B | classic_bike | 2023-01-06 19:34:50 | 2023-01-06 19:50:01 | Clark St & Elm St | TA1307000039 | Southport Ave & Clybourn Ave | TA1309000030 | 41.902973 | -87.631280 | 41.920771 | -87.663712 | casual | 15.0 | 3.3345 |
| 6081639 | 1A4EB636346DF527 | classic_bike | 2023-01-13 18:59:24 | 2023-01-13 19:14:44 | Clark St & Elm St | TA1307000039 | Southport Ave & Clybourn Ave | TA1309000030 | 41.902973 | -87.631280 | 41.920771 | -87.663712 | casual | 15.0 | 3.3345 |
| 6081640 | 069971675AC7DC62 | electric_bike | 2023-01-02 13:48:29 | 2023-01-02 13:59:29 | Clark St & Elm St | TA1307000039 | Southport Ave & Clybourn Ave | TA1309000030 | 41.902822 | -87.631687 | 41.920771 | -87.663712 | casual | 11.0 | 3.3175 |